package com.zhou.imaotai.mapper;

import com.zhou.imaotai.core.BaseMapperX;
import com.zhou.imaotai.entity.IItem;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

/**
 * @author lcz
 * @desc I茅台预约商品Mapper接口
 * @mail lcz_0130@163.com
 * @date 2023-07-02
 */
@Mapper
public interface IItemMapper extends BaseMapperX<IItem> {
    //清空指定表
    @Update("truncate table i_item")
    void truncateItem();

    //根据商品code查询商品标题
    @Select("select title from i_item where item_code = #{itemCode}")
    String selectByItemCode(String itemCode);

}
